
	
/****** Object:  Stored Procedure [dbo].UsersUpdate    Script Date: Thursday, March 18, 2010 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spUsersUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[spUsersUpdate]
GO
			
	
	

	
/******************************************************************************
**		File: 
**		Name: [dbo].spUsersUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/18/2010 5:03:21 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE [dbo].spUsersUpdate
	@Mobile nvarchar(20), 
	@Password nvarchar(50), 
	@Email nchar(120), 
	@Ten nvarchar(25), 
	@Ho nvarchar(50), 
	@NgSinh smalldatetime, 
	@Phai nvarchar(20), 
	@DChi nvarchar(250), 
	@NhanMail bit, 
	@NhanSMS bit, 
	@ThanhPho int, 
	@Quan int, 
	@NgonNgu int, 
	@NguoiGioiThieu nvarchar(20), 
	@MaSoCaNhan nvarchar(20) 
AS

UPDATE [dbo].[Users] SET
	[Password] = @Password,
	[Email] = @Email,
	[Ten] = @Ten,
	[Ho] = @Ho,
	[NgSinh] = @NgSinh,
	[Phai] = @Phai,
	[DChi] = @DChi,
	[NhanMail] = @NhanMail,
	[NhanSMS] = @NhanSMS,
	[ThanhPho] = @ThanhPho,
	[Quan] = @Quan,
	[NgonNgu] = @NgonNgu,
	[NguoiGioiThieu] = @NguoiGioiThieu,
	[MaSoCaNhan] = @MaSoCaNhan
WHERE
	[Mobile] = @Mobile

GO

